package com.dingding.order.core.grab.sql;

/**
 * 
 * @ClassName: UserGrabSQL 
 * @Description: 用户抢单SQL
 * @author YHQ
 * @date 2016年8月26日 下午3:54:51
 * @since V2.4.0
 * 
 */
public class UserGrabSQL {

	// 用户抢单推送信息
	public static String USER_GRAB_PUSH = "SELECT ul.aliasId,ul.loginEquipment,uot.appointTime AS grabOrderTime,vi.lisencePlate,ui.nickName,uot.specialOrderId AS oid,uot.orderStatus,uot.publishType,ui.sex,ui.telPhone AS telePhone,ui.userAvatar,ui.userTabloidAvatar,ui.userLevel,vi.vehicleColor,vi.vehicleImage,vi.vehicleModel,vi.vehicleType,uot.estimateDistance,uot.estimateMoney,uot.distance,uot.totalMoney FROM userspecialordert uot INNER JOIN userlogin ul ON uot.placeOrderUserId = ul.uid LEFT JOIN specialuserinfo uif ON uif.userId = uot.grabOrderUserId LEFT JOIN specialuserinfo ui ON ui.userId = ? LEFT JOIN specialuservehicleinfo vi ON ui.userId = vi.userId WHERE uot.specialOrderId = ?";

}
